VLOOKUP Function

The VLOOKUP function in Excel is used to search for a value in the first column of a table and return a value in the same row from another column. It stands for "Vertical Lookup" and is one of the most commonly used functions for looking up and referencing data.

Syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value: The value you want to search for in the first column of the table.
• table_array: The range of cells that contains the data you want to search through.
• col_index_num: The column number in the table array from which to return the value.
• range_lookup: (Optional) TRUE for an approximate match; FALSE for an exact match.

Example:

If you have a table in A2:C10 with product names in column A, product IDs in column B, and prices in column C, you could use =VLOOKUP("Product Name", A2:C10, 3, FALSE) to find the price of a specific product.